Sale by Item

Report Parameters

Field

Description

Report Name

The name of the report.

Start Date

The start date from when the data must be considered for generating the report.

End Date

The end date until when the data must be considered for generating the report.

Filter to certain items only

Enabling this will allow generating of reports based on a specific item number. Enter the desired item number(s).

Report Category(s)

Select the preferred report category from the drop-down list.

Category

Select the preferred item category for generating the report.

Subcategory 1 to 5

A list of all the available subcategories based on the selected category are displayed.

User(s)

Select preferred user(s) from the drop-down list.

Detail by Outlet

When enabled, generates a detailed report based on the outlet.

Summary by Outlet

When enabled, generates a summarized report based on the outlet.

Include Inactive Users

When enabled, inactive users will be included in the report.

Page Break

When enabled, page breaks are added in the report.

Sample Report

Table

Description automatically generated

Report Fields

Field

Description

Date

The date the transaction was made.

Ticket

The ticket number associated with the transaction.

User

The name of the user associated with the transaction.

Qty

The number of the items.

Cost

The cost of the item.

Margin

The margin percentage of the item.

Net Amount

The amount of item based on the quantity ordered.

Outlet

The name of the outlet associated with the transaction.

Current Qty-On Hand

The number of items currently on hand.

Item Totals

The total number of items involved in the transaction.

Outlet Totals

The total of the number of items, total cost, margin, and net amount columns for each outlet.

Grand Total Sales

The total of the number of items, total cost, margin, and net amount columns for all outlets.